﻿using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace ProjectSunny
{
    public partial class Index : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            rpt_Box.DataSource = DAL.DCollector.DBCollector.Instance.CallSQL1Param( "select * from tbl_Category where Category_ID2=0 AND Category_ActiveLeft = 1",true);
            rpt_Box.DataBind();
            string id = DAL.DCollector.DBCollector.Instance.StoredSelectTable("tbl_BoxCategory").Rows[0]["Category_ID1"].ToString();
            rpt_topdichvuweb.DataSource = DAL.DCollector.DBCollector.Instance.CallSQL1Param( "select * from tbl_Category where Category_ID2="+id, true);
            rpt_topdichvuweb.DataBind();
        }
    }
}